# Query Description # Type of request: Extract data from a table # Name of the selected table: sophies # Description of the table: Spectra (series truncated to the first observation) # SQL constraint on fields: get_spec is not null # Order by: date desc # Description of each column # $link[objname]: ------ Designation of the object # $j2000: -------------- J2000 coordinates # $link['S']: ---------- Link to Simbad database # $link['E']: ---------- # seq: ----------------- Sequence number # $link[slen]: --------- Length of the series # date: ---------------- Calendar date of observation # mode: ---------------- Observation mode: High resolution or High efficiency # fiber_b: ------------- Use of the second fiber (DARK, WAVE or SKY) # exptime: ------------- exposure time # sn26: ---------------- Signal/noise in order 26 # $link[view_spec]: ---- # $link[view_head]: ---- # $link[get_spec]: ----- # $link[get_e2ds]: ----- # $link[customize]: ---- # $link[search_ccf]: --- #-------------------- ---------------- --- --- --------------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- #$link[objname] $j2000 $li $li seq $lin date mode fibe exptim sn2 $link[vie $link[vie $link[ge $link[ge $link[cus $link[sear # nk[ nk[ k[sl r_b e 6 w_spec] w_head] t_spec] t_e2ds] tomize] ch_ccf] # 'S' 'E' en] # ] ] #-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- HD189733 J200043.8+224239 S E 3414740 1 2023-07-14 HR FP 360.0 89 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3414170 1 2023-07-13 HR FP 360.0 78 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3413630 1 2023-07-12 HR FP 360.0 71 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3412750 1 2023-07-11 HR FP 360.0 50 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3412130 1 2023-07-10 HR FP 360.0 93 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3411610 1 2023-07-09 HR FP 360.0 75 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3410860 1 2023-07-08 HR FP 360.0 88 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3409240 1 2023-07-05 HR FP 360.0 65 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3408580 1 2023-07-04 HR FP 360.0 91 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3408010 1 2023-07-03 HR FP 360.0 75 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3407400 1 2023-07-02 HR FP 360.0 66 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3406790 1 2023-07-01 HR FP 360.0 83 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3406290 1 2023-06-30 HR FP 360.0 53 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3405340 1 2023-06-28 HR FP 360.0 67 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3404840 1 2023-06-25 HR FP 360.0 67 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3404190 1 2023-06-24 HR FP 360.0 83 view_spec view_head get_spec get_e2ds customize search_CCF HD189733 J200043.8+224239 S E 3403370 1 2023-06-23 HR FP 360.0 56 view_spec view_head get_spec get_e2ds customize search_CCF GSC1985-0374 J115503.0+241541 S E 3385760 1 2023-05-15 HE SKY 1500.0 29 view_spec view_head get_spec get_e2ds customize search_CCF GSC1986-0269 J121357.0+250511 S E 3385790 1 2023-05-15 HE SKY 1300.0 30 view_spec view_head get_spec get_e2ds customize search_CCF TYC2004-0745-1 J133918.4+285134 S E 3385820 1 2023-05-15 HE SKY 3300.0 55 view_spec view_head get_spec get_e2ds customize search_CCF GSC1985-0374 J115503.0+241541 S E 3385770 1 2023-05-15 HE SKY 1500.0 25 view_spec view_head get_spec get_e2ds customize search_CCF GSC1986-0269 J121357.0+250511 S E 3385800 1 2023-05-15 HE SKY 1300.0 29 view_spec view_head get_spec get_e2ds customize search_CCF GSC1985-0374 J115503.0+241541 S E 3385780 1 2023-05-15 HE SKY 1500.0 28 view_spec view_head get_spec get_e2ds customize search_CCF GSC1986-0269 J121357.0+250511 S E 3385810 1 2023-05-15 HE SKY 1300.0 27 view_spec view_head get_spec get_e2ds customize search_CCF HD127911 J143244.3+434523 S E 3385230 1 2023-05-14 HR SKY 900.0 48 view_spec view_head get_spec get_e2ds customize search_CCF BD+112576 J132959.8+102238 S E 3385210 1 2023-05-14 HR SKY 1800.0 92 view_spec view_head get_spec get_e2ds customize search_CCF TYC3924-1678-1 J191226.1+543825 S E 3385420 1 2023-05-14 HR SKY 1000.0 29 view_spec view_head get_spec get_e2ds customize search_CCF TYC3367-0631-1 J184618.4+502932 S E 3385430 1 2023-05-14 HR SKY 1000.0 40 view_spec view_head get_spec get_e2ds customize search_CCF TYC2494-0712-1 J092946.6+300347 S E 3385130 1 2023-05-14 HR SKY 1800.0 28 view_spec view_head get_spec get_e2ds customize search_CCF HD185144 J193221.6+693940 S E 3385360 1 2023-05-14 HR FP 300.0 337 view_spec view_head get_spec get_e2ds customize search_CCF #-- end of data table ---------------------------------------------------------- # 30 lines were successfully retrieved